package com.example.hotelmanager.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.hotelmanager.entity.Cost;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author :chenjie
 * @date :Created 2022/11/27 22:50
 */
@Mapper
public interface CostMapper extends BaseMapper<Cost> {
    @Select("update cost set state = 11 where room_id = #{roomId} and (state = 0 or state = 1)")
    void settleCostByRoomId(String roomId);
}
